Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Subquery
1) A correlated subquery relies on the main query for its processing
2) A query that required a derived table
3) A query that uses a correlated subquery in its SELECT clause to retrieve the most recent Billing for each Banker
4) A query that uses three subqueries
5) A subquery can be used with other comparison operators
6) ALL with subquery
7) Building a Nested Subquery
8) Correlated subquery using Group By
9) Correlated subquery using TOP 1
10) Creating a Derived Table
11) Delete with subquery
12) Doing calculation with subquery
13) Finding First Employee Using a Derived Table
14) ID NOT IN (SELECT ID FROM Title)
15) In-Line Views (Derived Tables)
16) Join and sub query
17) Join with (inline)Table Expressions
18) Queries in the FROM Clause
19) Select from nested select statements
20) SELECT list FROM (query that returns a regular result set) AS alias name JOIN some other base or derived table
21) Subqueries and Comparison Operators
22) Subqueries and Derived Tables
23) Subqueries and IN Operator
24) Subqueries are SELECT statements that are nested within another T-SQL statement
25) Subqueries can be nested
26) Subquery returned more than 1 value This is not permitted when the subquery follows =, !=, , = , , = or when the subquery is used
27) Subquery with =
28) Using SELECT DISTINCT or a GROUP BY statement in the inner query
29) Using Subqueries to Check for the Existence of Matches
30) Using Subqueries to Check for the Existence of Matches between two tables